﻿DROP PROCEDURE [dbo].[cms_sp_MediaContentSave]
GO

create procedure [dbo].[cms_sp_MediaContentSave]
(
@Id int,
@MediaId int,
@SiteId int,
@SiteGroupId int,
@MetaCode nvarchar(150),
@Description nvarchar(500),
@CreatedBy int,
@DateCreated datetime,
@LastUpdatedBy int,
@DateLastUpdated datetime,
@MediaContentName nvarchar(250),
@BlockFromSearchEngines bit = 0
)
as

update dbo.MediaContents
set 
	MediaId = @MediaId
   ,SiteId = @SiteId
   ,SiteGroupId = @SiteGroupId
   ,MetaCode = @MetaCode
   ,[Description] = @Description
   ,CreatedBy = @CreatedBy
   ,DateCreated = @DateCreated
   ,LastUpdatedBy = @LastUpdatedBy
   ,DateLastUpdated = @DateLastUpdated
   ,MediaContentName = @MediaContentName
   ,BlockFromSearchEngines = @BlockFromSearchEngines
where MediaContentId = @Id

GO


